﻿<?xml version="1.0" encoding="utf-8" ?>
<TestSuite xmlns="http://tempuri.org/SsisUnit.xsd">
  <ConnectionList>
    <Connection name="AdventureWorks" connection="Provider=SQLNCLI;Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Adventureworks" connectionType="ConnectionString"/>
  </ConnectionList>
  <PackageList>
    <Package name="filePkg" packagePath="C:\Projects\SSISUnit\SSIS2005\SSIS2005\UT Basic Scenario.dtsx" storageType="FileSystem"/>
    <Package name="msdbPkg" packagePath="\\UT Basic Scenario" server="localhost" storageType="MSDB"/>
    <Package name="ssPkg" packagePath="\File System\UT Basic Scenario" server="localhost" storageType="PackageStore"/>
  </PackageList>
  <Setup>
    
  </Setup>
  <Tests>
    <Test name="testLocal" package="C:\Projects\SSISUnit\SSIS2005\SSIS2005\UT Basic Scenario.dtsx" task="SELECT COUNT">
      <Assert name="test" expectedResult="1" testBefore="false">
        <SqlCommand connectionRef="AdventureWorks" returnsValue="true">
          SELECT 1
        </SqlCommand>
      </Assert>
    </Test>
    <Test name="testFile" package="filePkg" task="SELECT COUNT">
      <Assert name="test" expectedResult="1" testBefore="false">
        <SqlCommand connectionRef="AdventureWorks" returnsValue="true">
          SELECT 1
        </SqlCommand>
      </Assert>
    </Test>
    <Test name="testmsdb" package="msdbPkg" task="SELECT COUNT">
      <Assert name="test" expectedResult="1" testBefore="false">
        <SqlCommand connectionRef="AdventureWorks" returnsValue="true">
          SELECT 1
        </SqlCommand>
      </Assert>
    </Test>
    <Test name="testSS" package="ssPkg" task="SELECT COUNT">
      <Assert name="test" expectedResult="1" testBefore="false">
        <SqlCommand connectionRef="AdventureWorks" returnsValue="true">
          SELECT 1
        </SqlCommand>
      </Assert>
    </Test>
  </Tests>
  <Teardown>
  </Teardown>
</TestSuite>